package ird.demo.repository;

import ird.demo.domain.User;


public interface UsrRepository extends BaseRepository< User, String>{
//	@Query(value = "SELECT * FROM USERS WHERE EMAIL_ADDRESS = ?0", nativeQuery = true)
	
	public static final String FIND_TRAN_BY_TRANGRP_SQL = "select t FROM Irugtgtb ugtg, Irtgtrtb tg, Irtrantb t where ugtg.TRAN_GRP=tg.TRAN_GRP and tg.TRAN_ID=t.TRAN_ID and ugtg.USR_GRP=:usrGrpId";
	
//	@Query(value = "select t from Irtrantb t where", nativeQuery = true)
//	List<Irtrantb> findTransByTranGrp(@Param("usrGrpId") String usrGrpId);
	
//	List<Irtrantb> findTransByMenu(@Param("grpId") String grpId);
}